﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using NENAData.Factory;
using NENAData.LINQ;

namespace NENAData.DLC
{
    public class ENAODistricts
    {

        private static MembershipDataContext GetMembershipDB()
        {
            var x = new SQLMembership();
            return x.GetMembershipDB();
        }
        

        public List<ENAO_District> GetDistricts_All()
        {
            MembershipDataContext db = GetMembershipDB();
            var listDistricts = (from district in db.ENAO_Districts
                                 where district.Active_Status == "Y"
                                 select district);
            return listDistricts.ToList();
        }

    }
}
